
select sum(rpag)*0.01 as Gross,sum(rpaap)*0.01 as Open from c0053prdd/f03b11 
where rppst = 'A'




select rpmcu, sum(rpag)*0.01 as Gross,sum(rpaap)*0.01 as Open from c0053prdd/f03b11 
where rppst = 'A'
group by RPmcu
order by rpmcu


select rpan8, rpmcu, sum(rpag)*0.01 as Gross,sum(rpaap)*0.01 as Open from c0053prdd/f03b11 
where rppst = 'A'
and rpmcu in ('         055','        1380','        1446','        1447','        1486','        1783') 
group by RPan8, rpmcu
order by rpmcu